<!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" data-whc_version="25.0">
    <head><link rel="shortcut icon" href="../../../oxygen-webhelp/template/images/favicon.png"/><link rel="icon" href="../../../oxygen-webhelp/template/images/favicon.png"/><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/><meta name="viewport" content="width=device-width, initial-scale=1.0"/><meta http-equiv="X-UA-Compatible" content="IE=edge"/><meta name="copyright" content="(C) Copyright 2024"/><meta name="generator" content="DITA-OT"/><meta name="description" content="Supported pipeline types: Data Collector The SAP HANA Query Consumer origin reads from an SAP HANA database using the specified SQL query. For information about supported versions, see Supported ..."/><meta name="prodname" content="Data Collector"/><meta name="version" content="3"/><meta name="release" content="16"/><meta name="modification" content="0"/>        
      <title>SAP HANA Query Consumer</title><!--  Generated with Oxygen version 25.1, build number 2023042410.  --><meta name="wh-path2root" content="../../../"/><meta name="wh-toc-id" content="concept_pmt_ml3_3mb-d16893e30605"/><meta name="wh-source-relpath" content="datacollector/UserGuide/Origins/SAPHana.dita"/><meta name="wh-out-relpath" content="datacollector/UserGuide/Origins/SAPHana.html"/>

    <link rel="stylesheet" type="text/css" href="../../../oxygen-webhelp/app/commons.css?buildId=2023042410"/>
    <link rel="stylesheet" type="text/css" href="../../../oxygen-webhelp/app/topic.css?buildId=2023042410"/>

    <script src="../../../oxygen-webhelp/app/options/properties.js?buildId=20240802104629"></script>
    <script src="../../../oxygen-webhelp/app/localization/strings.js?buildId=2023042410"></script>
    <script src="../../../oxygen-webhelp/app/search/index/keywords.js?buildId=20240802104629"></script>
    <script defer="defer" src="../../../oxygen-webhelp/app/commons.js?buildId=2023042410"></script>
    <script defer="defer" src="../../../oxygen-webhelp/app/topic.js?buildId=2023042410"></script>
<link rel="stylesheet" type="text/css" href="../../../oxygen-webhelp/template/light.css?buildId=2023042410"/><link rel="stylesheet" type="text/css" href="../../../skin.css"/></head>

    <body class="wh_topic_page frmBody">
        
        
        

        
<nav class="navbar navbar-default wh_header" data-whc_version="25.0">
    <div class="container-fluid">
        <div class="wh_header_flex_container navbar-nav navbar-expand-md navbar-dark">
            <div class="wh_logo_and_publication_title_container">
                <div class="wh_logo_and_publication_title">
                    
                    <!--
                            This component will be generated when the next parameters are specified in the transformation scenario:
                            'webhelp.logo.image' and 'webhelp.logo.image.target.url'.
                            See: http://oxygenxml.com/doc/versions/17.1/ug-editor/#topics/dita_webhelp_output.html.
                    -->
                    
                    <div class=" wh_publication_title "><a href="../../../index.html"><span class="booktitle">  <span class="ph mainbooktitle"><span class="ph">Data Collector</span> User Guide</span>  </span></a></div>
                    
                </div>
                
                <!-- The menu button for mobile devices is copied in the output only when the 'webhelp.show.top.menu' parameter is set to 'yes' -->
                
            </div>

            <div class="wh_top_menu_and_indexterms_link collapse navbar-collapse">
                
                
                <div class=" wh_indexterms_link "><a href="../../../indexTerms.html" title="Index" aria-label="Go to index terms page"><span>Index</span></a></div>
                
            </div>
        </div>
    </div>
</nav>

        <div class=" wh_search_input navbar-form wh_topic_page_search search " role="form">


<form id="searchForm" method="get" role="search" action="../../../search.html"><div><input type="search" placeholder="Search " class="wh_search_textfield" id="textToSearch" name="searchQuery" aria-label="Search query" required="required"/><button type="submit" class="wh_search_button" aria-label="Search"><span class="search_input_text">Search</span></button></div></form>

</div>
        
        <div class="container-fluid">
            <div class="row">

                <nav class="wh_tools d-print-none">
                    
<div data-tooltip-position="bottom" class=" wh_breadcrumb "><ol class="d-print-none"><li><span class="home"><a href="../../../index.html"><span>Home</span></a></span></li><li><div class="topicref" data-id="concept_yjl_nc5_jq"><div class="title"><a href="../../../datacollector/UserGuide/Origins/Origins_title.html">Origins</a></div></div></li><li class="active"><div class="topicref" data-id="concept_pmt_ml3_3mb"><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_pmt_ml3_3mb">SAP HANA Query Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li></ol></div>



                    <div class="wh_right_tools "><button class="wh_hide_highlight" aria-label="Toggle search highlights" title="Toggle search highlights"></button><button class="webhelp_expand_collapse_sections" data-next-state="collapsed" aria-label="Collapse sections" title="Collapse sections"></button><div class=" wh_navigation_links "><span id="topic_navigation_links" class="navheader">
  
<span class="navprev"><a class="- topic/link link" href="../../../datacollector/UserGuide/Origins/SalesforceBAPI2.html#concept_yk2_tcw_ysb" title="Salesforce Bulk API 2.0" aria-label="Previous topic: Salesforce Bulk API 2.0" rel="prev"></a></span>  
<span class="navnext"><a class="- topic/link link" href="../../../datacollector/UserGuide/Origins/SDC_RPCorigin.html#concept_agb_5c1_ct" title="SDC RPC (deprecated)" aria-label="Next topic: SDC RPC (deprecated)" rel="next"></a></span>  </span></div>
<!--External resource link-->
<div class=" wh_print_link print d-none d-md-inline-block "><button onClick="window.print()" title="Print this page" aria-label="Print this page"></button></div>
                        
                        
                        
                        
                    </div>
                </nav>
            </div>

            

<div class="wh_content_area">
                <div class="row">
                    


                        <nav role="navigation" id="wh_publication_toc" class="col-lg-3 col-md-3 col-sm-12 d-md-block d-none d-print-none">
<div id="wh_publication_toc_content">


                            <div class=" wh_publication_toc " data-tooltip-position="right"><span class="expand-button-action-labels"><span id="button-expand-action" role="button" aria-label="Expand"></span><span id="button-collapse-action" role="button" aria-label="Collapse"></span><span id="button-pending-action" role="button" aria-label="Pending"></span></span><ul role="tree" aria-label="Table of Contents"><li role="treeitem" aria-expanded="false"><div data-tocid="concept_htw_ghg_jq-d16893e53" class="topicref" data-id="concept_htw_ghg_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_htw_ghg_jq-d16893e53-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Getting_Started/GettingStarted_Title.html#concept_htw_ghg_jq" id="concept_htw_ghg_jq-d16893e53-link">Getting Started</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_l2v_nlp_mpb-d16893e331" class="topicref" data-id="concept_l2v_nlp_mpb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_l2v_nlp_mpb-d16893e331-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/ReleaseNotes/ReleaseNotes.html#concept_l2v_nlp_mpb" id="concept_l2v_nlp_mpb-d16893e331-link">Release Notes</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_l4q_flb_kr-d16893e2582" class="topicref" data-id="concept_l4q_flb_kr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_l4q_flb_kr-d16893e2582-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Installation/Install_title.html" id="concept_l4q_flb_kr-d16893e2582-link">Installation</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ylh_yyz_ky-d16893e3984" class="topicref" data-id="concept_ylh_yyz_ky" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ylh_yyz_ky-d16893e3984-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Configuration/Config_title.html" id="concept_ylh_yyz_ky-d16893e3984-link">Configuration</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ejk_f1f_5v-d16893e7058" class="topicref" data-id="concept_ejk_f1f_5v" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ejk_f1f_5v-d16893e7058-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Upgrade/Upgrade_title.html" id="concept_ejk_f1f_5v-d16893e7058-link">Upgrade</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qsw_cjy_bt-d16893e10103" class="topicref" data-id="concept_qsw_cjy_bt" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qsw_cjy_bt-d16893e10103-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Design/PipelineDesign_title.html" id="concept_qsw_cjy_bt-d16893e10103-link">Pipeline Concepts and Design</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qn1_wn4_kq-d16893e11199" class="topicref" data-id="concept_qn1_wn4_kq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qn1_wn4_kq-d16893e11199-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Configuration/PipelineConfiguration_title.html" id="concept_qn1_wn4_kq-d16893e11199-link">Pipeline Configuration</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hdr_gyw_41b-d16893e13057" class="topicref" data-id="concept_hdr_gyw_41b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hdr_gyw_41b-d16893e13057-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Data_Formats/DataFormats-Title.html" id="concept_hdr_gyw_41b-d16893e13057-link">Data Formats</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="true"><div data-tocid="concept_yjl_nc5_jq-d16893e14164" class="topicref" data-id="concept_yjl_nc5_jq" data-state="expanded"><span role="button" tabindex="0" aria-labelledby="button-collapse-action concept_yjl_nc5_jq-d16893e14164-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Origins_title.html" id="concept_yjl_nc5_jq-d16893e14164-link">Origins</a></div></div><ul role="group" class="navbar-nav nav-list"><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hpr_twm_jq-d16893e14186" class="topicref" data-id="concept_hpr_twm_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hpr_twm_jq-d16893e14186-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Origins_overview.html#concept_hpr_twm_jq" id="concept_hpr_twm_jq-d16893e14186-link">Origins</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_kvs_3hh_ht-d16893e14389" class="topicref" data-id="concept_kvs_3hh_ht" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_kvs_3hh_ht-d16893e14389-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/AmazonS3.html#concept_kvs_3hh_ht" id="concept_kvs_3hh_ht-d16893e14389-link">Amazon S3</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xsh_knm_5bb-d16893e14683" class="topicref" data-id="concept_xsh_knm_5bb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xsh_knm_5bb-d16893e14683-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/AmazonSQS.html#concept_xsh_knm_5bb" id="concept_xsh_knm_5bb-d16893e14683-link">Amazon SQS Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_mmf_dft_zsb-d16893e14861" class="topicref" data-id="concept_mmf_dft_zsb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_mmf_dft_zsb-d16893e14861-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/AuroraPostgreSQL.html#concept_mmf_dft_zsb" id="concept_mmf_dft_zsb-d16893e14861-link">Aurora PostgreSQL CDC Client</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ost_qqh_2xb-d16893e15160" class="topicref" data-id="concept_ost_qqh_2xb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ost_qqh_2xb-d16893e15160-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/AzureBlobStorage.html#concept_ost_qqh_2xb" id="concept_ost_qqh_2xb-d16893e15160-link">Azure Blob Storage</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_osx_qgz_xhb-d16893e15430" class="topicref" data-id="concept_osx_qgz_xhb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_osx_qgz_xhb-d16893e15430-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/ADLS-G1.html#concept_osx_qgz_xhb" id="concept_osx_qgz_xhb-d16893e15430-link">Azure Data Lake Storage Gen1 (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jmn_csn_zwb-d16893e15995" class="topicref" data-id="concept_jmn_csn_zwb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jmn_csn_zwb-d16893e15995-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/ADLS-G2v2.html#concept_jmn_csn_zwb" id="concept_jmn_csn_zwb-d16893e15995-link">Azure Data Lake Storage Gen2</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_osx_qgz_xhb-d16893e16287" class="topicref" data-id="concept_osx_qgz_xhb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_osx_qgz_xhb-d16893e16287-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/ADLS-G2.html#concept_osx_qgz_xhb" id="concept_osx_qgz_xhb-d16893e16287-link">Azure Data Lake Storage Gen2 (Legacy)</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_c1z_15q_1bb-d16893e16836" class="topicref" data-id="concept_c1z_15q_1bb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_c1z_15q_1bb-d16893e16836-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/AzureEventHub.html#concept_c1z_15q_1bb" id="concept_c1z_15q_1bb-d16893e16836-link">Azure IoT/Event Hub Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wfy_ghn_sz-d16893e16970" class="topicref" data-id="concept_wfy_ghn_sz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wfy_ghn_sz-d16893e16970-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/CoAPServer.html#concept_wfy_ghn_sz" id="concept_wfy_ghn_sz-d16893e16970-link">CoAP Server</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_nsz_mnr_2jb-d16893e17114" class="topicref" data-id="concept_nsz_mnr_2jb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_nsz_mnr_2jb-d16893e17114-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/CronScheduler.html#concept_nsz_mnr_2jb" id="concept_nsz_mnr_2jb-d16893e17114-link">Cron Scheduler</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wqr_cjc_fzb-d16893e17204" class="topicref" data-id="concept_wqr_cjc_fzb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wqr_cjc_fzb-d16893e17204-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Couchbase.html#concept_wqr_cjc_fzb" id="concept_wqr_cjc_fzb-d16893e17204-link">Couchbase</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qcq_54n_jq-d16893e17360" class="topicref" data-id="concept_qcq_54n_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qcq_54n_jq-d16893e17360-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Directory.html#concept_qcq_54n_jq" id="concept_qcq_54n_jq-d16893e17360-link">Directory</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_f1q_vpm_2z-d16893e17732" class="topicref" data-id="concept_f1q_vpm_2z" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_f1q_vpm_2z-d16893e17732-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Elasticsearch.html#concept_f1q_vpm_2z" id="concept_f1q_vpm_2z-d16893e17732-link">Elasticsearch </a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_n1y_qyp_5q-d16893e17922" class="topicref" data-id="concept_n1y_qyp_5q" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_n1y_qyp_5q-d16893e17922-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/FileTail.html#concept_n1y_qyp_5q" id="concept_n1y_qyp_5q-d16893e17922-link">File Tail</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_cg3_y3v_q1b-d16893e18251" class="topicref" data-id="concept_cg3_y3v_q1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_cg3_y3v_q1b-d16893e18251-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/BigQuery.html#concept_cg3_y3v_q1b" id="concept_cg3_y3v_q1b-d16893e18251-link">Google BigQuery</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_iyd_wql_nbb-d16893e18415" class="topicref" data-id="concept_iyd_wql_nbb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_iyd_wql_nbb-d16893e18415-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/GCS.html#concept_iyd_wql_nbb" id="concept_iyd_wql_nbb-d16893e18415-link">Google Cloud Storage</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pjw_qtl_r1b-d16893e18593" class="topicref" data-id="concept_pjw_qtl_r1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pjw_qtl_r1b-d16893e18593-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/PubSub.html#concept_pjw_qtl_r1b" id="concept_pjw_qtl_r1b-d16893e18593-link">Google Pub/Sub Subscriber</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_chr_zjj_l3b-d16893e18735" class="topicref" data-id="concept_chr_zjj_l3b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_chr_zjj_l3b-d16893e18735-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/GroovyScripting.html#concept_chr_zjj_l3b" id="concept_chr_zjj_l3b-d16893e18735-link">Groovy Scripting</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yp1_4zs_yfb-d16893e18980" class="topicref" data-id="concept_yp1_4zs_yfb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yp1_4zs_yfb-d16893e18980-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/gRPCClient.html#concept_yp1_4zs_yfb" id="concept_yp1_4zs_yfb-d16893e18980-link">gRPC Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_lw2_tnm_vs-d16893e19098" class="topicref" data-id="concept_lw2_tnm_vs" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_lw2_tnm_vs-d16893e19098-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/HadoopFS-origin.html#concept_lw2_tnm_vs" id="concept_lw2_tnm_vs-d16893e19098-link">Hadoop FS (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_djz_pdm_hdb-d16893e19313" class="topicref" data-id="concept_djz_pdm_hdb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_djz_pdm_hdb-d16893e19313-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/HDFSStandalone.html#concept_djz_pdm_hdb" id="concept_djz_pdm_hdb-d16893e19313-link">Hadoop FS Standalone</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wk4_bjz_5r-d16893e19947" class="topicref" data-id="concept_wk4_bjz_5r" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wk4_bjz_5r-d16893e19947-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/HTTPClient.html#concept_wk4_bjz_5r" id="concept_wk4_bjz_5r-d16893e19947-link">HTTP Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_s2p_5hb_4y-d16893e20461" class="topicref" data-id="concept_s2p_5hb_4y" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_s2p_5hb_4y-d16893e20461-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/HTTPServer.html#concept_s2p_5hb_4y" id="concept_s2p_5hb_4y-d16893e20461-link">HTTP Server</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_kn5_bvt_m3b-d16893e20645" class="topicref" data-id="concept_kn5_bvt_m3b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_kn5_bvt_m3b-d16893e20645-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/JavaScriptScripting.html#concept_kn5_bvt_m3b" id="concept_kn5_bvt_m3b-d16893e20645-link">JavaScript Scripting</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_zp3_wnw_4y-d16893e20872" class="topicref" data-id="concept_zp3_wnw_4y" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_zp3_wnw_4y-d16893e20872-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MultiTableJDBCConsumer.html#concept_zp3_wnw_4y" id="concept_zp3_wnw_4y-d16893e20872-link">JDBC Multitable Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qhf_hjr_bs-d16893e21646" class="topicref" data-id="concept_qhf_hjr_bs" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qhf_hjr_bs-d16893e21646-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/JDBCConsumer.html#concept_qhf_hjr_bs" id="concept_qhf_hjr_bs-d16893e21646-link">JDBC Query Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ywk_rq3_qbc-d16893e22216" class="topicref" data-id="concept_ywk_rq3_qbc" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ywk_rq3_qbc-d16893e22216-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Jira.html#concept_ywk_rq3_qbc" id="concept_ywk_rq3_qbc-d16893e22216-link">Jira</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_rhh_4nj_dt-d16893e22336" class="topicref" data-id="concept_rhh_4nj_dt" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_rhh_4nj_dt-d16893e22336-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/JMS.html#concept_rhh_4nj_dt" id="concept_rhh_4nj_dt-d16893e22336-link">JMS Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_fxz_35t_m3b-d16893e22495" class="topicref" data-id="concept_fxz_35t_m3b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_fxz_35t_m3b-d16893e22495-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/JythonScripting.html#concept_fxz_35t_m3b" id="concept_fxz_35t_m3b-d16893e22495-link">Jython Scripting</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_msz_wnr_5q-d16893e22744" class="topicref" data-id="concept_msz_wnr_5q" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_msz_wnr_5q-d16893e22744-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/KConsumer.html#concept_msz_wnr_5q" id="concept_msz_wnr_5q-d16893e22744-link">Kafka Consumer (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ccs_fn4_x1b-d16893e22908" class="topicref" data-id="concept_ccs_fn4_x1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ccs_fn4_x1b-d16893e22908-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/KafkaMultiConsumer.html#concept_ccs_fn4_x1b" id="concept_ccs_fn4_x1b-d16893e22908-link">Kafka Multitopic Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_anh_4y3_yr-d16893e23093" class="topicref" data-id="concept_anh_4y3_yr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_anh_4y3_yr-d16893e23093-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/KinConsumer.html#concept_anh_4y3_yr" id="concept_anh_4y3_yr-d16893e23093-link">Kinesis Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qwj_5vm_pbb-d16893e23299" class="topicref" data-id="concept_qwj_5vm_pbb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qwj_5vm_pbb-d16893e23299-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MapRdbCDC.html#concept_qwj_5vm_pbb" id="concept_qwj_5vm_pbb-d16893e23299-link">MapR DB CDC</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ywh_k15_3y-d16893e23433" class="topicref" data-id="concept_ywh_k15_3y" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ywh_k15_3y-d16893e23433-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MapRDBJSON.html#concept_ywh_k15_3y" id="concept_ywh_k15_3y-d16893e23433-link">MapR DB JSON</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_psz_db4_lx-d16893e23504" class="topicref" data-id="concept_psz_db4_lx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_psz_db4_lx-d16893e23504-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MapRFS.html#concept_psz_db4_lx" id="concept_psz_db4_lx-d16893e23504-link">MapR FS (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_b43_3qc_mdb-d16893e23678" class="topicref" data-id="concept_b43_3qc_mdb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_b43_3qc_mdb-d16893e23678-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MapRFSStandalone.html#concept_b43_3qc_mdb" id="concept_b43_3qc_mdb-d16893e23678-link">MapR FS Standalone</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hvd_hww_lbb-d16893e24077" class="topicref" data-id="concept_hvd_hww_lbb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hvd_hww_lbb-d16893e24077-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MapRStreamsMultiConsumer.html#concept_hvd_hww_lbb" id="concept_hvd_hww_lbb-d16893e24077-link">MapR Multitopic Streams Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_cvy_xsf_2v-d16893e24258" class="topicref" data-id="concept_cvy_xsf_2v" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_cvy_xsf_2v-d16893e24258-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MapRStreamsCons.html#concept_cvy_xsf_2v" id="concept_cvy_xsf_2v-d16893e24258-link">MapR Streams Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_bk4_2rs_ns-d16893e24398" class="topicref" data-id="concept_bk4_2rs_ns" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_bk4_2rs_ns-d16893e24398-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MongoDB.html#concept_bk4_2rs_ns" id="concept_bk4_2rs_ns-d16893e24398-link">MongoDB</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_vcz_zkw_m5b-d16893e24598" class="topicref" data-id="concept_vcz_zkw_m5b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_vcz_zkw_m5b-d16893e24598-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MongoDBAtlas.html#concept_vcz_zkw_m5b" id="concept_vcz_zkw_m5b-d16893e24598-link">MongoDB Atlas</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_u4n_g2b_jzb-d16893e24876" class="topicref" data-id="concept_u4n_g2b_jzb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_u4n_g2b_jzb-d16893e24876-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MongoDBAtlasCDC.html#concept_u4n_g2b_jzb" id="concept_u4n_g2b_jzb-d16893e24876-link">MongoDB Atlas CDC</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_mjn_yqw_4y-d16893e25084" class="topicref" data-id="concept_mjn_yqw_4y" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_mjn_yqw_4y-d16893e25084-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MongoDBOplog.html#concept_mjn_yqw_4y" id="concept_mjn_yqw_4y-d16893e25084-link">MongoDB Oplog</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ukz_3vt_lz-d16893e25263" class="topicref" data-id="concept_ukz_3vt_lz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ukz_3vt_lz-d16893e25263-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MQTTSubscriber.html#concept_ukz_3vt_lz" id="concept_ukz_3vt_lz-d16893e25263-link">MQTT Subscriber</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_kqg_1yh_xx-d16893e25400" class="topicref" data-id="concept_kqg_1yh_xx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_kqg_1yh_xx-d16893e25400-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/MySQLBinaryLog.html#concept_kqg_1yh_xx" id="concept_kqg_1yh_xx-d16893e25400-link">MySQL Binary Log</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ynn_vdb_p3b-d16893e25681" class="topicref" data-id="concept_ynn_vdb_p3b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ynn_vdb_p3b-d16893e25681-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/NiFi.html#concept_ynn_vdb_p3b" id="concept_ynn_vdb_p3b-d16893e25681-link">NiFi HTTP Server (deprecated)</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_dsr_xmw_1s-d16893e25727" class="topicref" data-id="concept_dsr_xmw_1s" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_dsr_xmw_1s-d16893e25727-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Omniture.html#concept_dsr_xmw_1s" id="concept_dsr_xmw_1s-d16893e25727-link">Omniture (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_nmf_1ly_f1b-d16893e25773" class="topicref" data-id="concept_nmf_1ly_f1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_nmf_1ly_f1b-d16893e25773-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/OPCUAClient.html#concept_nmf_1ly_f1b" id="concept_nmf_1ly_f1b-d16893e25773-link">OPC UA Client </a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_lnz_kzp_zgb-d16893e25887" class="topicref" data-id="concept_lnz_kzp_zgb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_lnz_kzp_zgb-d16893e25887-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/OracleBulk.html#concept_lnz_kzp_zgb" id="concept_lnz_kzp_zgb-d16893e25887-link">Oracle Bulkload</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_bv1_kwt_pbc-d16893e26121" class="topicref" data-id="concept_bv1_kwt_pbc" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_bv1_kwt_pbc-d16893e26121-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/OracleMultitableConsumer.html#concept_bv1_kwt_pbc" id="concept_bv1_kwt_pbc-d16893e26121-link">Oracle Multitable Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_whr_2w2_bwb-d16893e26812" class="topicref" data-id="concept_whr_2w2_bwb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_whr_2w2_bwb-d16893e26812-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/OracleC.html#concept_whr_2w2_bwb" id="concept_whr_2w2_bwb-d16893e26812-link">Oracle CDC</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_rs5_hjj_tw-d16893e27509" class="topicref" data-id="concept_rs5_hjj_tw" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_rs5_hjj_tw-d16893e27509-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/OracleCDC.html#concept_rs5_hjj_tw" id="concept_rs5_hjj_tw-d16893e27509-link">Oracle CDC Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_cfs_4m4_n2b-d16893e28270" class="topicref" data-id="concept_cfs_4m4_n2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_cfs_4m4_n2b-d16893e28270-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/PostgreSQL.html#concept_cfs_4m4_n2b" id="concept_cfs_4m4_n2b-d16893e28270-link">PostgreSQL CDC Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="PulsarMultiConsumer-d16893e28573" class="topicref" data-id="PulsarMultiConsumer" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action PulsarMultiConsumer-d16893e28573-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/PulsarConsumerV2.html#PulsarMultiConsumer" id="PulsarMultiConsumer-d16893e28573-link">Pulsar Consumer</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_o2b_1pc_r2b-d16893e28883" class="topicref" data-id="concept_o2b_1pc_r2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_o2b_1pc_r2b-d16893e28883-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/PulsarConsumer.html#concept_o2b_1pc_r2b" id="concept_o2b_1pc_r2b-d16893e28883-link">Pulsar Consumer (Legacy)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_dyg_lq1_h5-d16893e29195" class="topicref" data-id="concept_dyg_lq1_h5" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_dyg_lq1_h5-d16893e29195-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/RabbitMQ.html#concept_dyg_lq1_h5" id="concept_dyg_lq1_h5-d16893e29195-link">RabbitMQ Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_plr_t3v_jw-d16893e29310" class="topicref" data-id="concept_plr_t3v_jw" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_plr_t3v_jw-d16893e29310-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Redis.html#concept_plr_t3v_jw" id="concept_plr_t3v_jw-d16893e29310-link">Redis Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hfg_2sn_p2b-d16893e29403" class="topicref" data-id="concept_hfg_2sn_p2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hfg_2sn_p2b-d16893e29403-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/RESTService.html#concept_hfg_2sn_p2b" id="concept_hfg_2sn_p2b-d16893e29403-link">REST Service </a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_odf_vr3_rx-d16893e29750" class="topicref" data-id="concept_odf_vr3_rx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_odf_vr3_rx-d16893e29750-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Salesforce.html#concept_odf_vr3_rx" id="concept_odf_vr3_rx-d16893e29750-link">Salesforce</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yk2_tcw_ysb-d16893e30273" class="topicref" data-id="concept_yk2_tcw_ysb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yk2_tcw_ysb-d16893e30273-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SalesforceBAPI2.html#concept_yk2_tcw_ysb" id="concept_yk2_tcw_ysb-d16893e30273-link">Salesforce Bulk API 2.0</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="true" class="active"><div data-tocid="concept_pmt_ml3_3mb-d16893e30605" class="topicref" data-id="concept_pmt_ml3_3mb" data-state="expanded"><span role="button" tabindex="0" aria-labelledby="button-collapse-action concept_pmt_ml3_3mb-d16893e30605-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_pmt_ml3_3mb" id="concept_pmt_ml3_3mb-d16893e30605-link">SAP HANA Query Consumer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div><ul role="group" class="navbar-nav nav-list"><li role="treeitem"><div data-tocid="concept_onp_gyp_3mb-d16893e30629" class="topicref" data-id="concept_onp_gyp_3mb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_onp_gyp_3mb" id="concept_onp_gyp_3mb-d16893e30629-link">Installing the JDBC Driver</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem"><div data-tocid="concept_u4t_txp_3mb-d16893e30653" class="topicref" data-id="concept_u4t_txp_3mb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_u4t_txp_3mb" id="concept_u4t_txp_3mb-d16893e30653-link">Offset Column and Offset Value</a><div class="wh-tooltip"><p class="shortdesc">The SAP HANA Query Consumer origin <span class="ph">uses an offset column and initial offset value to determine                 where to start reading data within a table. Include both the offset column and the                 offset value in the WHERE clause of the SQL query. </span></p></div></div></div></li><li role="treeitem"><div data-tocid="concept_k1t_y1q_3mb-d16893e30680" class="topicref" data-id="concept_k1t_y1q_3mb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_k1t_y1q_3mb" id="concept_k1t_y1q_3mb-d16893e30680-link">Full and Incremental Mode</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem"><div data-tocid="concept_u1z_ggq_3mb-d16893e30704" class="topicref" data-id="concept_u1z_ggq_3mb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_u1z_ggq_3mb" id="concept_u1z_ggq_3mb-d16893e30704-link">Recovery</a><div class="wh-tooltip"><p class="shortdesc">The SAP HANA Query Consumer origin <span class="ph">supports recovery after a deliberate or unexpected stop when it                 performs incremental queries. Recovery is not supported for full queries.</span></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_dvl_nqq_3mb-d16893e30731" class="topicref" data-id="concept_dvl_nqq_3mb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_dvl_nqq_3mb-d16893e30731-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_dvl_nqq_3mb" id="concept_dvl_nqq_3mb-d16893e30731-link">SQL Query</a><div class="wh-tooltip"><p class="shortdesc">The SQL query defines the data returned from the database.</p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_gq3_v4v_3mb-d16893e30800" class="topicref" data-id="concept_gq3_v4v_3mb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_gq3_v4v_3mb-d16893e30800-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_gq3_v4v_3mb" id="concept_gq3_v4v_3mb-d16893e30800-link">JDBC Attributes</a><div class="wh-tooltip"><p class="shortdesc">The SAP HANA Query Consumer origin generates record header attributes and field         attributes that provide additional information about each record and field. </p></div></div></div></li><li role="treeitem"><div data-tocid="concept_o1q_zkj_jmb-d16893e30869" class="topicref" data-id="concept_o1q_zkj_jmb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_o1q_zkj_jmb" id="concept_o1q_zkj_jmb-d16893e30869-link">SAP HANA Header Attributes</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_lqj_nvv_3mb-d16893e30893" class="topicref" data-id="concept_lqj_nvv_3mb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_lqj_nvv_3mb-d16893e30893-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#concept_lqj_nvv_3mb" id="concept_lqj_nvv_3mb-d16893e30893-link">Event Generation</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem"><div data-tocid="task_xkt_kww_gmb-d16893e30939" class="topicref" data-id="task_xkt_kww_gmb" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SAPHana.html#task_xkt_kww_gmb" id="task_xkt_kww_gmb-d16893e30939-link">Configuring an SAP HANA Query Consumer Origin</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li></ul></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_agb_5c1_ct-d16893e30963" class="topicref" data-id="concept_agb_5c1_ct" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_agb_5c1_ct-d16893e30963-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SDC_RPCorigin.html#concept_agb_5c1_ct" id="concept_agb_5c1_ct-d16893e30963-link">SDC RPC (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ic5_bzd_5v-d16893e31009" class="topicref" data-id="concept_ic5_bzd_5v" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ic5_bzd_5v-d16893e31009-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SFTP.html#concept_ic5_bzd_5v" id="concept_ic5_bzd_5v-d16893e31009-link">SFTP/FTP/FTPS Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_svf_4zr_3xb-d16893e31260" class="topicref" data-id="concept_svf_4zr_3xb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_svf_4zr_3xb-d16893e31260-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SnowflakeBulk.html#concept_svf_4zr_3xb" id="concept_svf_4zr_3xb-d16893e31260-link">Snowflake Bulk</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="SQLServerBDCMultitable-d16893e31552" class="topicref" data-id="SQLServerBDCMultitable" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action SQLServerBDCMultitable-d16893e31552-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SQLServerBDCMultitable.html#SQLServerBDCMultitable" id="SQLServerBDCMultitable-d16893e31552-link">SQL Server 2019 BDC Multitable Consumer (deprecated)</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ut3_ywc_v1b-d16893e32229" class="topicref" data-id="concept_ut3_ywc_v1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ut3_ywc_v1b-d16893e32229-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SQLServerCDC.html#concept_ut3_ywc_v1b" id="concept_ut3_ywc_v1b-d16893e32229-link">SQL Server CDC Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ewq_b2s_r1b-d16893e32613" class="topicref" data-id="concept_ewq_b2s_r1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ewq_b2s_r1b-d16893e32613-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SQLServerChange.html#concept_ewq_b2s_r1b" id="concept_ewq_b2s_r1b-d16893e32613-link">SQL Server Change Tracking</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ufc_53w_wlb-d16893e32972" class="topicref" data-id="concept_ufc_53w_wlb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ufc_53w_wlb-d16893e32972-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/StartJob.html#concept_ufc_53w_wlb" id="concept_ufc_53w_wlb-d16893e32972-link">Start Jobs</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_h1l_xpr_2jb-d16893e33106" class="topicref" data-id="concept_h1l_xpr_2jb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_h1l_xpr_2jb-d16893e33106-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/StartPipe.html#concept_h1l_xpr_2jb" id="concept_h1l_xpr_2jb-d16893e33106-link">Start Pipelines (deprecated)</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_gzy_gmv_32b-d16893e33200" class="topicref" data-id="concept_gzy_gmv_32b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_gzy_gmv_32b-d16893e33200-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/SystemMetrics.html#concept_gzy_gmv_32b" id="concept_gzy_gmv_32b-d16893e33200-link">System Metrics</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ppm_xb1_4z-d16893e33296" class="topicref" data-id="concept_ppm_xb1_4z" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ppm_xb1_4z-d16893e33296-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/TCPServer.html#concept_ppm_xb1_4z" id="concept_ppm_xb1_4z-d16893e33296-link">TCP Server</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_zp3_wnw_4y-d16893e33474" class="topicref" data-id="concept_zp3_wnw_4y" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_zp3_wnw_4y-d16893e33474-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Teradata.html#concept_zp3_wnw_4y" id="concept_zp3_wnw_4y-d16893e33474-link">Teradata Consumer (deprecated)</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wng_g5f_5bb-d16893e34151" class="topicref" data-id="concept_wng_g5f_5bb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wng_g5f_5bb-d16893e34151-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/UDPMulti.html#concept_wng_g5f_5bb" id="concept_wng_g5f_5bb-d16893e34151-link">UDP Multithreaded Source</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_rst_2y5_1s-d16893e34307" class="topicref" data-id="concept_rst_2y5_1s" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_rst_2y5_1s-d16893e34307-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/UDP.html#concept_rst_2y5_1s" id="concept_rst_2y5_1s-d16893e34307-link">UDP Source</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jd3_qxg_51c-d16893e34397" class="topicref" data-id="concept_jd3_qxg_51c" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jd3_qxg_51c-d16893e34397-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/WebClientO.html#concept_jd3_qxg_51c" id="concept_jd3_qxg_51c-d16893e34397-link">Web Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_unk_nzk_fbb-d16893e34782" class="topicref" data-id="concept_unk_nzk_fbb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_unk_nzk_fbb-d16893e34782-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/WebSocketClient.html#concept_unk_nzk_fbb" id="concept_unk_nzk_fbb-d16893e34782-link">WebSocket Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_u2r_gpc_3z-d16893e34919" class="topicref" data-id="concept_u2r_gpc_3z" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_u2r_gpc_3z-d16893e34919-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/WebSocketServer.html#concept_u2r_gpc_3z" id="concept_u2r_gpc_3z-d16893e34919-link">WebSocket Server</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_agf_5jv_sbb-d16893e35128" class="topicref" data-id="concept_agf_5jv_sbb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_agf_5jv_sbb-d16893e35128-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/WindowsLog.html#concept_agf_5jv_sbb" id="concept_agf_5jv_sbb-d16893e35128-link">Windows Event Log</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li></ul></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yjl_nc5_jq-d16893e35197" class="topicref" data-id="concept_yjl_nc5_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yjl_nc5_jq-d16893e35197-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Processors/Processors_title.html" id="concept_yjl_nc5_jq-d16893e35197-link">Processors</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_agj_cfj_br-d16893e44037" class="topicref" data-id="concept_agj_cfj_br" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_agj_cfj_br-d16893e44037-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Destinations-title.html" id="concept_agj_cfj_br-d16893e44037-link">Destinations</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_umc_1lk_fx-d16893e56072" class="topicref" data-id="concept_umc_1lk_fx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_umc_1lk_fx-d16893e56072-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/Executors-title.html" id="concept_umc_1lk_fx-d16893e56072-link">Executors</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xxd_f5r_kx-d16893e59696" class="topicref" data-id="concept_xxd_f5r_kx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xxd_f5r_kx-d16893e59696-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Event_Handling/EventFramework-Title.html#concept_xxd_f5r_kx" id="concept_xxd_f5r_kx-d16893e59696-link">Dataflow Triggers</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_zq5_pb4_flb-d16893e60134" class="topicref" data-id="concept_zq5_pb4_flb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_zq5_pb4_flb-d16893e60134-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Solutions/Solutions-title.html" id="concept_zq5_pb4_flb-d16893e60134-link">Solutions</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ugp_kwf_xw-d16893e61337" class="topicref" data-id="concept_ugp_kwf_xw" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ugp_kwf_xw-d16893e61337-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/DPM/DPM_title.html" id="concept_ugp_kwf_xw-d16893e61337-link">StreamSets Control Hub</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_fyf_gkq_4bb-d16893e62693" class="topicref" data-id="concept_fyf_gkq_4bb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_fyf_gkq_4bb-d16893e62693-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Edge_Mode/EdgePipelines_title.html" id="concept_fyf_gkq_4bb-d16893e62693-link"><span class="ph">StreamSets Data Collector Edge</span></a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wwq_gxc_py-d16893e63980" class="topicref" data-id="concept_wwq_gxc_py" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wwq_gxc_py-d16893e63980-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Multithreaded_Pipelines/MultithreadedPipelines.html#concept_wwq_gxc_py" id="concept_wwq_gxc_py-d16893e63980-link">Multithreaded Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_gzw_tdm_p2b-d16893e64187" class="topicref" data-id="concept_gzw_tdm_p2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_gzw_tdm_p2b-d16893e64187-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Microservice/Microservice_Title.html#concept_gzw_tdm_p2b" id="concept_gzw_tdm_p2b-d16893e64187-link">Microservice Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="Orchestrators_Title-d16893e64348" class="topicref" data-id="Orchestrators_Title" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action Orchestrators_Title-d16893e64348-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Orchestration_Pipelines/OrchestrationPipelines_Title.html#Orchestrators_Title" id="Orchestrators_Title-d16893e64348-link">Orchestration Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wr1_ktz_bt-d16893e64489" class="topicref" data-id="concept_wr1_ktz_bt" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wr1_ktz_bt-d16893e64489-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/RPC_Pipelines/SDC_RPCpipelines_title.html#concept_wr1_ktz_bt" id="concept_wr1_ktz_bt-d16893e64489-link">SDC RPC Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_fpz_5r4_vs-d16893e64679" class="topicref" data-id="concept_fpz_5r4_vs" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_fpz_5r4_vs-d16893e64679-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Cluster_Mode/ClusterPipelines_title.html" id="concept_fpz_5r4_vs-d16893e64679-link">Cluster Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jjk_23z_sq-d16893e65172" class="topicref" data-id="concept_jjk_23z_sq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jjk_23z_sq-d16893e65172-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Data_Preview/DataPreview_Title.html#concept_jjk_23z_sq" id="concept_jjk_23z_sq-d16893e65172-link">Data Preview</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pgk_brx_rr-d16893e65458" class="topicref" data-id="concept_pgk_brx_rr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pgk_brx_rr-d16893e65458-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Alerts/RulesAlerts_title.html#concept_pgk_brx_rr" id="concept_pgk_brx_rr-d16893e65458-link">Rules and Alerts</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_asx_fdz_sq-d16893e65960" class="topicref" data-id="concept_asx_fdz_sq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_asx_fdz_sq-d16893e65960-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Monitoring/PipelineMonitoring_title.html#concept_asx_fdz_sq" id="concept_asx_fdz_sq-d16893e65960-link">Pipeline Monitoring</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_o3l_dtr_5q-d16893e66304" class="topicref" data-id="concept_o3l_dtr_5q" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_o3l_dtr_5q-d16893e66304-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Maintenance/PipelineMaintenance_title.html#concept_o3l_dtr_5q" id="concept_o3l_dtr_5q-d16893e66304-link">Pipeline Maintenance</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yms_ftm_sq-d16893e66768" class="topicref" data-id="concept_yms_ftm_sq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yms_ftm_sq-d16893e66768-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Administration/Administration_title.html#concept_yms_ftm_sq" id="concept_yms_ftm_sq-d16893e66768-link">Administration</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_nls_w1r_ks-d16893e67508" class="topicref" data-id="concept_nls_w1r_ks" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_nls_w1r_ks-d16893e67508-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Tutorial/Tutorial-title.html" id="concept_nls_w1r_ks-d16893e67508-link">Tutorial</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_sh3_frm_tq-d16893e68001" class="topicref" data-id="concept_sh3_frm_tq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_sh3_frm_tq-d16893e68001-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Troubleshooting/Troubleshooting_title.html#concept_sh3_frm_tq" id="concept_sh3_frm_tq-d16893e68001-link">Troubleshooting</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xbx_rs1_tq-d16893e68798" class="topicref" data-id="concept_xbx_rs1_tq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xbx_rs1_tq-d16893e68798-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Glossary/Glossary_title.html#concept_xbx_rs1_tq" id="concept_xbx_rs1_tq-d16893e68798-link">Glossary</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jn1_nzb_kv-d16893e68843" class="topicref" data-id="concept_jn1_nzb_kv" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jn1_nzb_kv-d16893e68843-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Apx-DataFormats/DataFormat_Title.html#concept_jn1_nzb_kv" id="concept_jn1_nzb_kv-d16893e68843-link">Data Formats by Stage</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pvm_yt3_wq-d16893e68958" class="topicref" data-id="concept_pvm_yt3_wq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pvm_yt3_wq-d16893e68958-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Expression_Language/ExpressionLanguage_title.html" id="concept_pvm_yt3_wq-d16893e68958-link">Expression Language</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_vcj_1ws_js-d16893e69669" class="topicref" data-id="concept_vcj_1ws_js" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_vcj_1ws_js-d16893e69669-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Apx-RegEx/RegEx-Title.html#concept_vcj_1ws_js" id="concept_vcj_1ws_js-d16893e69669-link">Regular Expressions</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_chv_vmj_wr-d16893e69787" class="topicref" data-id="concept_chv_vmj_wr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_chv_vmj_wr-d16893e69787-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Apx-GrokPatterns/GrokPatterns_title.html#concept_chv_vmj_wr" id="concept_chv_vmj_wr-d16893e69787-link">Grok Patterns</a></div></div></li></ul></div>
                        

</div>
</nav>
                    


                    
                    <div id="wh_topic_body" class="col-lg-7 col-md-9 col-sm-12">
<button id="wh_close_publication_toc_button" class="close-toc-button d-none" aria-label="Toggle publishing table of content" aria-controls="wh_publication_toc" aria-expanded="true"><span class="close-toc-icon-container"><span class="close-toc-icon"></span></span></button><button id="wh_close_topic_toc_button" class="close-toc-button d-none" aria-label="Toggle topic table of content" aria-controls="wh_topic_toc" aria-expanded="true"><span class="close-toc-icon-container"><span class="close-toc-icon"></span></span></button>

                        
<div class=" wh_topic_content body "><main role="main"><article class="" role="article" aria-labelledby="ariaid-title1"><article class="nested0" aria-labelledby="ariaid-title1" id="concept_pmt_ml3_3mb">
    <h1 class="- topic/title title topictitle1" id="ariaid-title1">SAP HANA Query Consumer</h1>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <div class="- topic/p p">
            <div class="simpletable-container"><table class="- topic/simpletable simpletable frame-none" id="concept_pmt_ml3_3mb__simpletable_q22_rqb_sgb" data-ofbid="concept_pmt_ml3_3mb__simpletable_q22_rqb_sgb"><colgroup><col style="width:100%"/></colgroup><tbody><tr class="- topic/strow strow">
                <td class="- topic/stentry stentry"><a class="- topic/xref xref" href="../Pipeline_Configuration/ProductIcons_Doc.html#concept_mjg_ly5_pgb">Supported pipeline types:</a><ul class="- topic/ul ul" id="concept_pmt_ml3_3mb__ul_s3x_b2m_rgb" data-ofbid="concept_pmt_ml3_3mb__ul_s3x_b2m_rgb">
                        <li class="- topic/li li">
                            <p class="- topic/p p"><img class="- topic/image image" id="concept_pmt_ml3_3mb__image_t3x_b2m_rgb" src="../../../reusable-content/datacollector/reusable-topics/../../shared-graphics/icon-SDC.png" height="21" width="21"/> Data Collector</p>
                        </li>
                    </ul></td>
            </tr></tbody></table></div>
        </div>
        <p class="- topic/p p">The SAP HANA Query Consumer
            origin reads from an SAP HANA database using the specified SQL query. <span class="- topic/ph ph">For information about supported versions, see <a class="- topic/xref xref" href="../Installation/SupportedSystemVersions.html#concept_s5h_bcr_n4b">Supported Systems and Versions</a>.</span></p>
        <p class="- topic/p p">The SQL query can read data from a single table or from a join of tables. The origin
            returns data as a map with column names and field values.</p>
        <p class="- topic/p p">When you configure SAP HANA Query Consumer, you specify connection information and
            credentials that determine how the origin connects to the database. You configure the
            query mode, SQL query and related information to define the data returned by the
            database. You can call stored procedures from the SQL query. </p>
        <p class="- topic/p p">You can enable SAP HANA split batch commands, which allow parallel execution of the query
            on partitioned tables. You can specify custom properties that your driver requires. <span class="- topic/ph ph">And you can specify what the origin does when
                        encountering an unsupported data type.</span></p>
        <p class="- topic/p p">By default, the origin generates JDBC record header attributes and JDBC field attributes
            that provide additional information about each record and field. You can configure the
            origin to generate SAP HANA record header attributes that provide details about the
            connection.</p>
        <p class="- topic/p p">The origin can generate events for an event stream. For
                  more information about dataflow triggers and the event framework, see <a class="- topic/xref xref" href="../Event_Handling/EventFramework-Title.html#concept_cph_5h4_lx">Dataflow Triggers Overview</a>. </p>
        <p class="- topic/p p">Before you use the origin, you must install a JDBC driver.</p>
    </div>
<article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title2" id="concept_onp_gyp_3mb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title2">Installing the JDBC Driver</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">Before you use the SAP HANA Query Consumer origin, <span class="- topic/ph ph">install the JDBC driver for the database. You cannot access
                        the database until you install the required driver. </span></p>
        <p class="- topic/p p">You install the driver into the JDBC SAP HANA stage library, <code class="+ topic/ph pr-d/codeph ph codeph"><span class="- topic/ph ph">streamsets-datacollector-jdbc-sap-hana-lib</span></code>, which includes the origin.</p>
        <p class="- topic/p p"><span class="- topic/ph ph">To use the JDBC driver
                with multiple stage libraries, install the driver into each stage library associated
                with the stages.</span></p>
        <p class="- topic/p p"><span class="- topic/ph ph">For information about installing additional drivers, <span class="- topic/ph ph" id="concept_onp_gyp_3mb__SDCDPM-ExtLibs-linksOnly">see <a class="- topic/xref xref" href="../Configuration/ExternalLibs.html#concept_pdv_qlw_ft">Install External Libraries</a>.</span></span></p>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title3" id="concept_u4t_txp_3mb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title3">Offset Column and Offset Value</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc">The SAP HANA Query Consumer origin <span class="- topic/ph ph">uses an offset column and initial offset value to determine
                where to start reading data within a table. Include both the offset column and the
                offset value in the WHERE clause of the SQL query. </span></p>
        <p class="- topic/p p"><span class="- topic/ph ph">The offset column must be a column in the table with unique
                non-null values, such as a primary key or indexed column. The initial offset value
                is a value within the offset column where you want the origin to start
            reading.</span></p>
        <p class="- topic/p p"><span class="- topic/ph ph">When the origin performs an incremental query, you must
                configure the offset column and offset value. For full queries, you can optionally
                configure them.</span></p>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title4" id="concept_k1t_y1q_3mb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title4">Full and Incremental Mode</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">The SAP HANA Query Consumer origin can perform
            queries in two modes:</p>
        <div class="- topic/p p">
            <dl class="- topic/dl dl">
                
                    <dt class="- topic/dt dt dlterm">Incremental mode</dt>
                    <dd class="- topic/dd dd"><span class="- topic/ph ph">To use incremental mode, you must select the Incremental
                            Mode property and configure an offset column and initial offset value
                            for the origin. When you define the SQL query, you must use the
                            ${OFFSET} parameter to represent the offset value in the WHERE
                            clause.</span></dd>
                    <dd class="- topic/dd dd ddexpand"><span class="- topic/ph ph">When the origin performs an incremental query, it
                            uses the initial offset value in place of the ${OFFSET} parameter in the
                            first SQL query. As the origin completes processing the results of the
                            first query, it saves the last offset value that it processes. Then it
                            waits the specified query interval before performing a subsequent query.
                        </span></dd>
                    <dd class="- topic/dd dd ddexpand"><span class="- topic/ph ph">When the origin performs a subsequent query, it uses
                            the last-saved offset value in place of the ${OFFSET} parameter in the
                            query. When needed, you can <a class="- topic/xref xref" href="../Pipeline_Maintenance/ResettingTheOrigin.html#task_hdg_j1s_5q">reset the origin</a>
                            to use the initial offset value. </span></dd>
                    <dd class="- topic/dd dd ddexpand"><span class="- topic/ph ph">Use incremental mode for append-only tables or when you
                            do not need to capture changes to older rows. By default, the origin
                            uses incremental mode. </span></dd>
                    <dd class="- topic/dd dd ddexpand">For more SQL query guidelines, see <a class="- topic/xref xref" href="SAPHana.html#concept_gqh_33v_3mb">SQL Query for Incremental Mode</a>.</dd>
                
                
                    <dt class="- topic/dt dt dlterm">Full mode</dt>
                    <dd class="- topic/dd dd"><span class="- topic/ph ph">To use full mode, you must clear the Incremental Mode
                            property for the origin. You can optionally configure an offset column
                            and initial offset value and can define any type of SQL query.</span></dd>
                    <dd class="- topic/dd dd ddexpand"><span class="- topic/ph ph">When the origin performs a full query, it runs the
                            specified SQL query. If you optionally configure the offset column and
                            initial offset value, the origin uses the initial offset as the offset
                            value in the SQL query each time it requests data.</span></dd>
                    <dd class="- topic/dd dd ddexpand"><span class="- topic/ph ph">When the origin completes processing the results of
                            the full query, it waits the specified query interval, and then performs
                            the same query again. </span></dd>
                    <dd class="- topic/dd dd ddexpand"><span class="- topic/ph ph">Use full mode to capture all row updates. You might use a
                            Record Deduplicator processor in the pipeline to minimize repeated rows.
                            Full mode is not ideal for large tables.</span></dd>
                    <dd class="- topic/dd dd ddexpand">
                        <div class="- topic/note note tip note_tip"><span class="note__title">Tip:</span> <span class="- topic/ph ph">If you want to process the results from a
                                single full query and then stop the pipeline, you can enable the
                                origin to generate events and use the Pipeline Finisher executor to
                                stop the pipeline automatically. For more information, see</span>
                            <a class="- topic/xref xref" href="SAPHana.html#concept_lqj_nvv_3mb">Event Generation</a>.</div>
                    </dd>
                    <dd class="- topic/dd dd ddexpand">For more SQL query guidelines, see <a class="- topic/xref xref" href="SAPHana.html#concept_qd1_vnv_3mb">SQL Query for Full Mode</a>.</dd>
                
            </dl>
        </div>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title5" id="concept_u1z_ggq_3mb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title5">Recovery</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc">The SAP HANA Query Consumer origin <span class="- topic/ph ph">supports recovery after a deliberate or unexpected stop when it
                performs incremental queries. Recovery is not supported for full queries.</span></p>
        <p class="- topic/p p"><span class="- topic/ph ph">In incremental mode, the origin uses offset values in the offset
                column to determine where to continue processing after a deliberate or unexpected
                stop. To ensure seamless recovery in incremental mode, use a primary key or indexed
                column as the offset column.</span> As the SAP HANA Query Consumer origin <span class="- topic/ph ph">processes data, it tracks the offset value internally.
                When the pipeline stops, the origin notes where it stopped processing data. When you
                restart the pipeline, it continues from the last-saved offset. </span></p>
        <p class="- topic/p p">When the origin <span class="- topic/ph ph">performs full queries, the origin runs
                the full query again after you restart the pipeline.</span></p>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title6" id="concept_dvl_nqq_3mb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title6">SQL Query</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc">The SQL query defines the data returned from the database.</p>
        <p class="- topic/p p">You define the query in the SQL Query property
            on the JDBC tab. Or, you can define the query in a <a class="- topic/xref xref" href="../Pipeline_Configuration/RuntimeValues.html#concept_bs4_5nm_2s" title="Similar to runtime properties, runtime resources are values that you define in a file local to the Data Collector and call from within a pipeline. But with runtime resources, you can restrict the permissions for the files to secure information.">runtime
                resource</a>, and then use the <code class="+ topic/ph pr-d/codeph ph codeph">runtime:loadResource</code> function in
            the SQL Query property to load the query from the resource file at runtime. For example,
            you might enter the following expression for the property:</p>
        <pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>${runtime:loadResource("myquery.sql", false)}</code></pre>
        <div class="- topic/p p"><span class="- topic/ph ph">The SQL query guidelines that you use depend on whether you
                configure the origin to perform an incremental or full query.</span><div class="- topic/note note note note_note"><span class="note__title">Note:</span> <span class="- topic/ph ph">Oracle uses all caps for schema, table, and column names by
                        default. Names can be lower- or mixed-case only if the schema, table, or
                        column was created with quotation marks around the name.</span></div></div>
    </div>
<article class="- topic/topic concept/concept topic concept nested2" aria-labelledby="ariaid-title7" id="concept_gqh_33v_3mb">
    <h3 class="- topic/title title topictitle3" id="ariaid-title7">SQL Query for Incremental Mode</h3>
    <div class="- topic/body concept/conbody body conbody">
        <p class="- topic/p p">When you define the SQL query for incremental
            mode, the SAP HANA Query Consumer origin requires a WHERE and ORDER BY clause in the
            query. </p>
        <p class="- topic/p p">Use the following guidelines when you define the WHERE and ORDER BY clauses in the
            query:</p>
        <div class="- topic/p p">
            <dl class="- topic/dl dl">
                
                    <dt class="- topic/dt dt dlterm">In the WHERE clause, include the offset column and the offset value</dt>
                    <dd class="- topic/dd dd">The origin uses an offset column and value to determine the data that is
                        returned. Include both in the WHERE clause of the query. </dd>
                
                
                    <dt class="- topic/dt dt dlterm">Use the OFFSET parameter to represent the offset value</dt>
                    <dd class="- topic/dd dd">In the WHERE clause, use ${OFFSET} to represent the offset value. </dd>
                    <dd class="- topic/dd dd ddexpand">For example, when you start a pipeline, the following query returns all data
                        from the table where the data in the offset column is greater than the
                        initial offset
                            value:<pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>SELECT * FROM &lt;tablename&gt; WHERE &lt;offset column&gt; &gt; ${OFFSET}</code></pre><div class="- topic/note note tip note_tip"><span class="note__title">Tip:</span> When the offset values are strings, enclose ${OFFSET} in
                            single quotation marks.</div></dd>
                
                
                    <dt class="- topic/dt dt dlterm">In the ORDER BY clause, include the offset column as the first column</dt>
                    <dd class="- topic/dd dd">To avoid returning duplicate data, use the offset column as the first column
                        in the ORDER BY clause.</dd>
                    <dd class="- topic/dd dd ddexpand">
                        <div class="- topic/note note note note_note"><span class="note__title">Note:</span> Using a column that is not a primary key or indexed column in the
                            ORDER BY clause can slow performance.</div>
                    </dd>
                
            </dl>
        </div>
        <div class="- topic/p p">For example, the following query for incremental mode returns data from
            an <code class="+ topic/ph pr-d/codeph ph codeph">invoice</code> table where the ID column is the offset column. The query
            returns all data where the ID is greater than the offset and orders the data by the
            ID:<pre class="+ topic/pre pr-d/codeblock pre codeblock"><code> SELECT * FROM invoice WHERE id &gt; ${OFFSET} ORDER BY id</code></pre></div>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested2" aria-labelledby="ariaid-title8" id="concept_qd1_vnv_3mb">
    <h3 class="- topic/title title topictitle3" id="ariaid-title8">SQL Query for Full Mode</h3>
    <div class="- topic/body concept/conbody body conbody">
        <p class="- topic/p p">You can define any type of SQL
            query for full mode. </p>
        <div class="- topic/p p">For example, you can run the following query to return all data from an
                <code class="+ topic/ph pr-d/codeph ph codeph">invoice</code> table:<pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>SELECT * FROM invoice</code></pre></div>
        <p class="- topic/p p">When you define the SQL query for full mode, you can optionally include
            the WHERE and ORDER BY clauses using the same guidelines as for incremental mode.
            However, using these clauses to read from large tables can cause performance issues.</p>
    </div>
</article></article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title9" id="concept_gq3_v4v_3mb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title9">JDBC Attributes</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc">The SAP HANA Query Consumer origin generates record header attributes and field
        attributes that provide additional information about each record and field. </p>
        <p class="- topic/p p">The origin receives these details from the JDBC driver.</p>
    </div>
<article class="- topic/topic concept/concept topic concept nested2" aria-labelledby="ariaid-title10" id="concept_rd3_y4v_3mb">
    <h3 class="- topic/title title topictitle3" id="ariaid-title10">JDBC Header Attributes </h3>
    <div class="- topic/body concept/conbody body conbody">
        <p class="- topic/p p">By default,
            the SAP HANA Query Consumer origin <span class="- topic/ph ph">generates JDBC record
                header attributes that provide additional information about each record, such as the
                original data type of a field or the source tables for the record. The origin
                receives these details from the JDBC driver. </span></p>
        <p class="- topic/p p"><span class="- topic/ph ph" id="concept_rd3_y4v_3mb__ph-functions">You can use the <code class="+ topic/ph pr-d/codeph ph codeph">record:attribute</code> or
                    <code class="+ topic/ph pr-d/codeph ph codeph">record:attributeOrDefault</code> functions to access the information
                in the attributes. For more information about working with record header attributes,
                see <a class="- topic/xref xref" href="../Pipeline_Design/RecordHeaderAttributes.html#concept_rd2_ghz_dz">Working with Header Attributes</a>.</span></p>
        <p class="- topic/p p"><span class="- topic/ph ph">JDBC header attributes include a user-defined prefix to
                differentiate the JDBC header attributes from other record header attributes. By
                default, the prefix is <code class="+ topic/ph pr-d/codeph ph codeph">jdbc</code>. </span></p>
        <p class="- topic/p p"><span class="- topic/ph ph">You can change the prefix that the origin uses and you can
                configure the origin not to create JDBC header attributes with the Create JDBC
                Header Attributes and JDBC Header Prefix properties on the Advanced tab.</span></p>
        <div class="- topic/p p">The origin can provide the following JDBC header attributes: <div class="table-container"><table class="- topic/table table frame-all" id="concept_rd3_y4v_3mb__table_p1c_q5c_kw" data-ofbid="concept_rd3_y4v_3mb__table_p1c_q5c_kw" data-cols="2"><caption></caption><colgroup><col style="width:40%"/><col style="width:60%"/></colgroup><thead class="- topic/thead thead">
                        <tr class="- topic/row">
                            <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__1">JDBC Header Attribute</th>
                            <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__2">Description</th>
                        </tr>
                    </thead><tbody class="- topic/tbody tbody">
                        <tr class="- topic/row" id="concept_rd3_y4v_3mb__entry-JDBC.tables">
                            <td class="- topic/entry entry colsep-1 rowsep-1" id="concept_rd3_y4v_3mb__entry-tables" headers="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__1"> &lt;JDBC prefix&gt;.tables</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" id="concept_rd3_y4v_3mb__entry_JDBCtables" headers="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__2">
                                <div class="- topic/p p" id="concept_rd3_y4v_3mb__p_JDBCtables" data-ofbid="concept_rd3_y4v_3mb__p_JDBCtables"><span class="- topic/ph ph" id="concept_rd3_y4v_3mb__ph-jdbc.tables-desc-providesListOfTables">Provides a
                                        comma-separated list of source tables for the fields in the
                                        record.</span><div class="- topic/note note note note_note" id="concept_rd3_y4v_3mb__note-jdbc.tables" data-ofbid="concept_rd3_y4v_3mb__note-jdbc.tables"><span class="note__title">Note:</span> Not all JDBC drivers
                                        provide this information.</div></div>
                            </td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" id="concept_rd3_y4v_3mb__entry-jdbcType" headers="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__1">&lt;JDBC prefix&gt;.&lt;column
                                name&gt;.jdbcType</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" id="concept_rd3_y4v_3mb__entry_JDBCType" headers="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__2"><span class="- topic/ph ph" id="concept_rd3_y4v_3mb__ph-Desc-jdbcType-attribute">Provides
                                    the numeric value of the original SQL data type for each field
                                    in the record. See the <a class="- topic/xref xref" href="https://docs.oracle.com/javase/8/docs/api/constant-values.html#java.sql.Types.ARRAY" target="_blank" rel="external noopener">Java documentation</a> for
                                    a list of the data types that correspond to numeric
                                values.</span></td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" id="concept_rd3_y4v_3mb__entry-precision" headers="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__1">&lt;JDBC prefix&gt;.&lt;column
                                name&gt;.precision</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" id="concept_rd3_y4v_3mb__entry_JDBCprecision" headers="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__2">Provides the original precision for all
                                numeric and decimal fields. </td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-0" id="concept_rd3_y4v_3mb__entry-scale" headers="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__1">&lt;JDBC prefix&gt;.&lt;column name&gt;.scale</td>
                            <td class="- topic/entry entry colsep-0 rowsep-0" id="concept_rd3_y4v_3mb__entry_JDBCscale" headers="concept_rd3_y4v_3mb__table_p1c_q5c_kw__entry__2">Provides the original scale for all numeric
                                and decimal fields. </td>
                        </tr>
                    </tbody></table></div></div>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested2" aria-labelledby="ariaid-title11" id="concept_ewl_2tv_3mb">
    <h3 class="- topic/title title topictitle3" id="ariaid-title11">JDBC Field Attributes</h3>
    <div class="- topic/body concept/conbody body conbody">
        <p class="- topic/p p">The SAP HANA Query Consumer origin
            generates field attributes for columns converted to the Decimal or Datetime data types
            in <span class="- topic/ph ph">Data Collector</span>.
            The attributes provide additional information about each field. </p>
        <div class="- topic/p p">The following data type conversions do not include all information in
            the corresponding <span class="- topic/ph ph">Data Collector</span>
            data type:<ul class="- topic/ul ul" id="concept_ewl_2tv_3mb__ul_v2b_mlg_wkb" data-ofbid="concept_ewl_2tv_3mb__ul_v2b_mlg_wkb">
                <li class="- topic/li li">Decimal and Numeric data types are converted to the <span class="- topic/ph ph">Data Collector</span> Decimal data type, which does not store scale and precision.</li>
                <li class="- topic/li li">The Timestamp data type is converted to the <span class="- topic/ph ph">Data Collector</span> Datetime data type, which does not store nanoseconds.</li>
            </ul></div>
        <div class="- topic/p p">To preserve this information during data type conversion, the origin
            generates the following field attributes for these <span class="- topic/ph ph">Data Collector</span>
            data types:<div class="table-container"><table class="- topic/table table frame-all" id="concept_ewl_2tv_3mb__table_fyk_pkg_wkb" data-ofbid="concept_ewl_2tv_3mb__table_fyk_pkg_wkb" data-cols="3"><caption></caption><colgroup><col style="width:16.666666666666664%"/><col style="width:25%"/><col style="width:58.333333333333336%"/></colgroup><thead class="- topic/thead thead">
                        <tr class="- topic/row">
                            <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__1"><span class="- topic/ph ph">Data Collector</span> Data Type</th>
                            <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__2">Generated Field Attribute</th>
                            <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__3">Description</th>
                        </tr>
                    </thead><tbody class="- topic/tbody tbody">
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__1">Decimal</td>
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__2">precision</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__3">Provides the original precision for every decimal or numeric
                                column.</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__1">Decimal</td>
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__2">scale</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__3">Provides the original scale for every decimal or numeric
                                column.</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__1">Datetime</td>
                            <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__2">nanoSeconds</td>
                            <td class="- topic/entry entry colsep-0 rowsep-0" headers="concept_ewl_2tv_3mb__table_fyk_pkg_wkb__entry__3">Provides the original nanoseconds for every timestamp
                                column.</td>
                        </tr>
                    </tbody></table></div></div>
        <p class="- topic/p p">You can use the <code class="+ topic/ph pr-d/codeph ph codeph">record:fieldAttribute</code> or
                <code class="+ topic/ph pr-d/codeph ph codeph">record:fieldAttributeOrDefault</code> functions to access the information
            in the attributes. For more information about working with field attributes, see <a class="- topic/xref xref" href="../Pipeline_Design/FieldAttributes.html#concept_xfm_wtp_1z">Field Attributes</a>.</p>
    </div>
</article></article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title12" id="concept_o1q_zkj_jmb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title12">SAP HANA Header Attributes</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">The SAP HANA
            Query Consumer origin can include SAP HANA connection information , such as the driver
            version or application name, in record header attributes. The origin receives these
            details from the JDBC driver. </p>
        <p class="- topic/p p">The attributes are named <code class="+ topic/ph pr-d/codeph ph codeph">SapHANA.&lt;attribute&gt;</code>.</p>
        <div class="- topic/p p">For example, the driver might include the following record header
            attributes:<pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>SapHANA.APPLICATIONUSER:&lt;user name&gt;
SapHANA.DRIVERVERSION:2.4.76-7ca985c0cc5ea9fa063ab376dab1bf7b859dd9cc
SapHANA.APPLICATION:com.streamsets.pipeline.BootstrapMain</code></pre></div>
        <p class="- topic/p p">Use the Include SAP HANA Connection Details on the SAP HANA tab to enable generating the
            SAP HANA header attributes.</p>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title13" id="concept_lqj_nvv_3mb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title13">Event Generation</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">The SAP HANA Query
            Consumer origin <span class="- topic/ph ph"><span class="- topic/ph ph" id="concept_lqj_nvv_3mb__EventGen-PipeFin-mini">can generate events that you can use in an event stream. When you
                              enable event generation, the origin generates an event when it
                              completes processing the data returned by the specified</span>
                        query.</span>
            <span class="- topic/ph ph">The origin also generates an event when a query completes successfully
                and when it fails to complete.</span></p>
        <div class="- topic/p p">Events generated by the origin can be used in any logical way. For example: <ul class="- topic/ul ul" id="concept_lqj_nvv_3mb__ul_i2s_3h1_4z" data-ofbid="concept_lqj_nvv_3mb__ul_i2s_3h1_4z">
                <li class="- topic/li li">With the Pipeline Finisher executor to stop the pipeline and
                    transition the pipeline to a Finished state when the origin completes processing
                    available data.<p class="- topic/p p">When you restart a pipeline stopped by the Pipeline Finisher
                        executor, the origin processes data based on how you configured the origin.
                        For example, if you configure the origin to run in incremental mode, the
                        origin saves the offset when the executor stops the pipeline. When it
                        restarts, the origin continues processing from the last-saved offset. In
                        contrast, if you configure the origin to run in full mode, when you restart
                        the pipeline, the origin uses the initial offset, if specified.</p><p class="- topic/p p">For an
                        example, see <a class="- topic/xref xref" href="../Solutions/StopPipeline.html#concept_kff_ykv_lz">Stopping a Pipeline After Processing All Available Data</a>.</p></li>
                <li class="- topic/li li">With the Email executor to send a custom email
                              after receiving an event.<p class="- topic/p p">For an example, see <a class="- topic/xref xref" href="../Solutions/SendEmail.html#concept_t2t_lp5_xz">Sending Email During Pipeline Processing</a>.</p></li>
            </ul><ul class="- topic/ul ul" id="concept_lqj_nvv_3mb__ul_cjg_c3s_kz" data-ofbid="concept_lqj_nvv_3mb__ul_cjg_c3s_kz">
                        <li class="- topic/li li">
                              <p class="- topic/p p">With a destination to store information about completed queries. </p>
                              <p class="- topic/p p">For an example, see <a class="- topic/xref xref" href="../Solutions/EventStorage.html#concept_ocb_nnl_px">Preserving an Audit Trail of Events</a>.</p>
                        </li>
                  </ul></div>
        <p class="- topic/p p"><span class="- topic/ph ph">For more information about dataflow
                        triggers and the event framework, see <a class="- topic/xref xref" href="../Event_Handling/EventFramework-Title.html#concept_cph_5h4_lx">Dataflow Triggers Overview</a>.</span></p>
    </div>
<article class="- topic/topic concept/concept topic concept nested2" aria-labelledby="ariaid-title14" id="concept_xlr_svv_3mb">
    <h3 class="- topic/title title topictitle3" id="ariaid-title14">Event Record</h3>
    <div class="- topic/body concept/conbody body conbody">
        <div class="- topic/p p">Event records generated by the SAP HANA
            Query Consumer origin have the following event-related record header attributes:<div class="table-container"><table class="- topic/table table frame-all" id="concept_xlr_svv_3mb__table_brz_3gp_qx" data-ofbid="concept_xlr_svv_3mb__table_brz_3gp_qx" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                        <tr class="- topic/row">
                            <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_xlr_svv_3mb__table_brz_3gp_qx__entry__1">Record Header Attribute</th>
                            <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_xlr_svv_3mb__table_brz_3gp_qx__entry__2">Description</th>
                        </tr>
                    </thead><tbody class="- topic/tbody tbody">
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_xlr_svv_3mb__table_brz_3gp_qx__entry__1">sdc.event.type</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_xlr_svv_3mb__table_brz_3gp_qx__entry__2">Event type. Uses one of the following types:<ul class="- topic/ul ul" id="concept_xlr_svv_3mb__ul_m12_mgp_qx" data-ofbid="concept_xlr_svv_3mb__ul_m12_mgp_qx">
                                    <li class="- topic/li li">no-more-data - Generated when the origin completes
                    processing all data returned by a query.</li>
                                    <li class="- topic/li li">jdbc-query-success - Generated when the origin
                    successfully completes a query.</li>
                                    <li class="- topic/li li">jdbc-query-failure - Generated when the origin fails to
                    complete a query.</li>
                                </ul></td>
                        </tr>
                        <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_xlr_svv_3mb__table_brz_3gp_qx__entry__1">sdc.event.version</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_xlr_svv_3mb__table_brz_3gp_qx__entry__2">Integer that indicates the version of the event record type.</td>
            </tr>
                        <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_xlr_svv_3mb__table_brz_3gp_qx__entry__1">sdc.event.creation_timestamp</td>
              <td class="- topic/entry entry colsep-0 rowsep-0" id="concept_xlr_svv_3mb__entry-Event-creationDate" headers="concept_xlr_svv_3mb__table_brz_3gp_qx__entry__2">Epoch timestamp when the stage created the event.
              </td>
            </tr>
                    </tbody></table></div></div>
        <div class="- topic/p p">The origin can generate the following types of event records:<dl class="- topic/dl dl">
                
                    <dt class="- topic/dt dt dlterm">No-more-data</dt>
                    <dd class="- topic/dd dd">The origin generates a no-more-data event record when it completes
                        processing all data returned by a query. </dd>
                    <dd class="- topic/dd dd ddexpand">When necessary, you can configure the origin to delay the generation of the
                        no-more-data event by a specified number of seconds. You might configure a
                        delay to ensure that the query success or query failure events are generated
                        and delivered to the pipeline before the no-more-data event record. To use a
                        delay, configure the No-more-data Event Generation Delay property on the
                        JDBC tab.</dd>
                    <dd class="- topic/dd dd ddexpand">No-more-data event records generated by the origin have the
                            <code class="+ topic/ph pr-d/codeph ph codeph">sdc.event.type</code> set to <code class="+ topic/ph pr-d/codeph ph codeph">no-more-data</code> and
                        include the following field:<div class="table-container"><table class="- topic/table table frame-all" id="concept_xlr_svv_3mb__table_fcv_xx4_j1b" data-ofbid="concept_xlr_svv_3mb__table_fcv_xx4_j1b" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                    <tr class="- topic/row">
                                        <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_xlr_svv_3mb__table_fcv_xx4_j1b__entry__1">Event Record Field</th>
                                        <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_xlr_svv_3mb__table_fcv_xx4_j1b__entry__2">Description</th>
                                    </tr>
                                </thead><tbody class="- topic/tbody tbody">
                                    <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_xlr_svv_3mb__table_fcv_xx4_j1b__entry__1">record-count</td>
              <td class="- topic/entry entry colsep-0 rowsep-0" headers="concept_xlr_svv_3mb__table_fcv_xx4_j1b__entry__2">Number of records successfully generated since the pipeline started or since
                the last no-more-data event was created. </td>
            </tr>
                                </tbody></table></div></dd>
                
                
                    <dt class="- topic/dt dt dlterm">Query success</dt>
                    <dd class="- topic/dd dd">The origin generates a query success event record when it completes
                        processing the data returned from a query. </dd>
                    <dd class="- topic/dd dd ddexpand">The query success event records have the <code class="+ topic/ph pr-d/codeph ph codeph">sdc.event.type</code>
                        record header attribute set to <code class="+ topic/ph pr-d/codeph ph codeph">jdbc-query-success</code> and
                        include the following fields:<div class="table-container"><table class="- topic/table table frame-all" id="concept_xlr_svv_3mb__table_dh2_5gc_rx" data-ofbid="concept_xlr_svv_3mb__table_dh2_5gc_rx" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                    <tr class="- topic/row">
                                        <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__1">Field</th>
                                        <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__2">Description</th>
                                    </tr>
                                </thead><tbody class="- topic/tbody tbody">
                                    <tr class="- topic/row">
                                        <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__1">query</td>
                                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__2">Query that completed successfully.</td>
                                    </tr>
                                    <tr class="- topic/row">
                                        <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__1">timestamp</td>
                                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__2">Timestamp when the query completed.</td>
                                    </tr>
                                    <tr class="- topic/row">
                                        <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__1">row-count</td>
                                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__2">Number of processed rows.</td>
                                    </tr>
                                    <tr class="- topic/row">
                                        <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__1">source-offset</td>
                                        <td class="- topic/entry entry colsep-0 rowsep-0" headers="concept_xlr_svv_3mb__table_dh2_5gc_rx__entry__2">Offset after the query completed.</td>
                                    </tr>
                                </tbody></table></div></dd>
                
                
                    <dt class="- topic/dt dt dlterm" id="concept_xlr_svv_3mb__dlentry-queryFailure" data-ofbid="concept_xlr_svv_3mb__dlentry-queryFailure">Query failure</dt>
                    <dd class="- topic/dd dd" id="concept_xlr_svv_3mb__dd-queryFailureGen">The origin generates a query failure event record
                        when it fails to complete processing the data returned from a query. </dd>
                    <dd class="- topic/dd dd ddexpand" id="concept_xlr_svv_3mb__dd-queryFailure-leadin">The query failure event records have the
                            <code class="+ topic/ph pr-d/codeph ph codeph">sdc.event.type</code> record header attribute set to
                            <code class="+ topic/ph pr-d/codeph ph codeph">jdbc-query-failure</code> and include the following
                        fields:</dd>
                    <dd class="- topic/dd dd ddexpand">
                        <div class="table-container"><table class="- topic/table table frame-all" id="concept_xlr_svv_3mb__table_ck5_mht_kz" data-ofbid="concept_xlr_svv_3mb__table_ck5_mht_kz" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                    <tr class="- topic/row" id="concept_xlr_svv_3mb__QF-tablehead">
                                        <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_xlr_svv_3mb__QF-tablehead__entry__1">Field</th>
                                        <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_xlr_svv_3mb__QF-tablehead__entry__2">Description</th>
                                    </tr>
                                </thead><tbody class="- topic/tbody tbody">
                                    <tr class="- topic/row" id="concept_xlr_svv_3mb__QF-queryrow">
                                        <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_xlr_svv_3mb__QF-tablehead__entry__1">query</td>
                                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_xlr_svv_3mb__QF-tablehead__entry__2">Query that failed to complete.</td>
                                    </tr>
                                    <tr class="- topic/row" id="concept_xlr_svv_3mb__QF-timestamprow">
                                        <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_xlr_svv_3mb__QF-tablehead__entry__1">timestamp</td>
                                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_xlr_svv_3mb__QF-tablehead__entry__2">Timestamp when the query failed to complete.</td>
                                    </tr>
                                    <tr class="- topic/row" id="concept_xlr_svv_3mb__QF-rowcountrow">
                                        <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_xlr_svv_3mb__QF-tablehead__entry__1">row-count</td>
                                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_xlr_svv_3mb__QF-tablehead__entry__2">Number of records from the query that were
                                            processed.</td>
                                    </tr>
                                    <tr class="- topic/row">
                                        <td class="- topic/entry entry colsep-1 rowsep-1" id="concept_xlr_svv_3mb__entry-QF-sourceOffset" headers="concept_xlr_svv_3mb__QF-tablehead__entry__1">source-offset</td>
                                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_xlr_svv_3mb__QF-tablehead__entry__2"><span class="- topic/ph ph" id="concept_xlr_svv_3mb__ph-QF-sourceOffset">Origin offset after query
                                                failure.</span></td>
                                    </tr>
                                    <tr class="- topic/row" id="concept_xlr_svv_3mb__QF-errorrow">
                                        <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_xlr_svv_3mb__QF-tablehead__entry__1">error</td>
                                        <td class="- topic/entry entry colsep-0 rowsep-0" headers="concept_xlr_svv_3mb__QF-tablehead__entry__2">First error message.</td>
                                    </tr>
                                </tbody></table></div>
                    </dd>
                
            </dl></div>
    </div>
</article></article><article class="- topic/topic task/task topic task nested1" aria-labelledby="ariaid-title15" id="task_xkt_kww_gmb">
    <h2 class="- topic/title title topictitle2" id="ariaid-title15">Configuring an SAP HANA Query Consumer Origin</h2>
    
    <div class="- topic/body task/taskbody body taskbody"><p class="- topic/shortdesc shortdesc"></p>
        <section class="- topic/section task/context section context">
            <p class="- topic/p p">Configure an SAP HANA Query
                Consumer origin to read from an SAP HANA database using the specified SQL query.
                Before you use the origin, you must <a class="- topic/xref xref" href="SAPHana.html#concept_onp_gyp_3mb">install a JDBC
                driver</a>.</p>
            <p class="- topic/p p">
                
            </p>
        </section>
        <section class="- topic/ol task/steps ol steps"><ol class="- topic/ol task/steps ol steps"><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">In the Properties panel, on the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">General</span> tab, configure the
                    following properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_xkt_kww_gmb__table_ac1_hss_5x" data-ofbid="task_xkt_kww_gmb__table_ac1_hss_5x" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_xkt_kww_gmb__table_ac1_hss_5x__entry__1">General Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_xkt_kww_gmb__table_ac1_hss_5x__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_ac1_hss_5x__entry__1">Name</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_ac1_hss_5x__entry__2">Stage name.</td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_ac1_hss_5x__entry__1">Description</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_ac1_hss_5x__entry__2">Optional description.</td>
            </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_ac1_hss_5x__entry__1"><a class="- topic/xref xref" href="JDBCConsumer.html#concept_o1c_kwr_kz">Produce Events</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_ac1_hss_5x__entry__2">Generates event records when events occur. Use for
                  <a class="- topic/xref xref" href="../Event_Handling/EventFramework-Title.html#concept_cph_5h4_lx">event handling</a>.</td>
                                </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_xkt_kww_gmb__table_ac1_hss_5x__entry__1"><a class="- topic/xref xref" href="../Pipeline_Design/ErrorHandling.html#concept_atr_j4y_5r">On Record Error</a></td>
              <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_xkt_kww_gmb__table_ac1_hss_5x__entry__2">Error record handling for the stage: <ul class="- topic/ul ul" id="task_xkt_kww_gmb__ul_h5l_np2_px" data-ofbid="task_xkt_kww_gmb__ul_h5l_np2_px">
                  <li class="- topic/li li">Discard - Discards the record.</li>
                  <li class="- topic/li li">Send to Error - Sends the record to the pipeline for error handling.</li>
                  <li class="- topic/li li">Stop Pipeline - Stops the pipeline. </li>
                </ul></td>
            </tr>
                            </tbody></table></div>
                </div>
            </li><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">JDBC</span> tab, configure the following properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_xkt_kww_gmb__table_nkm_dlr_bs" data-ofbid="task_xkt_kww_gmb__table_nkm_dlr_bs" data-cols="2"><caption></caption><colgroup><col style="width:22.22222222222222%"/><col style="width:77.77777777777779%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">JDBC Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Host</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Name of the host to connect to.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Port</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Port number to use.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Database</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Name of the database to connect to.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1"><a class="- topic/xref xref" href="SAPHana.html#concept_dvl_nqq_3mb" title="The SQL query defines the data returned from the database.">SQL Query</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">SQL query to use when reading data from the database.
                                            <p class="- topic/p p">Define the query in the property. Or, define the
                                            query in a <a class="- topic/xref xref" href="../Pipeline_Configuration/RuntimeValues.html#concept_bs4_5nm_2s" title="Similar to runtime properties, runtime resources are values that you define in a file local to the Data Collector and call from within a pipeline. But with runtime resources, you can restrict the permissions for the files to secure information.">runtime resource</a>, and then use the
                                                <code class="+ topic/ph pr-d/codeph ph codeph">runtime:loadResource</code> function in
                                            the property to load the query from the resource file at
                                            runtime. </p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Initial Offset </td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Offset value to use when the pipeline starts.<p class="- topic/p p">Required
                                            in incremental mode.</p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1"><a class="- topic/xref xref" href="SAPHana.html#concept_u4t_txp_3mb" title="The SAP HANA Query Consumer origin uses an offset column and initial offset value to determine where to start reading data within a table. Include both the offset column and the offset value in the WHERE clause of the SQL query.">Offset Column</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Column to use for the offset value. <p class="- topic/p p">As a best practice, an offset column should be an
                  incremental and unique column that does not contain null values. Having an index
                  on this column is strongly encouraged since the underlying query uses an ORDER BY
                  and inequality operators on this column.</p><p class="- topic/p p">Required in incremental mode.</p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Use Credentials</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Enables entering credentials on the Credentials
                                        tab.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1"><a class="- topic/xref xref" href="SAPHana.html#concept_k1t_y1q_3mb">Incremental Mode</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Defines how the origin queries the database. Select to
                                        perform incremental queries. Clear to perform full queries.
                                            <p class="- topic/p p">Default is incremental mode. </p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Root Field Type</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Root field type to use for generated records. Use the
                                        default List-Map option unless using the origin in a
                                        pipeline built with <span class="- topic/ph ph">Data Collector</span> version 1.1.0 or earlier.</td>
                                </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Query Interval</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Amount of time to wait between queries. Enter an expression based on a unit of
                time. You can use SECONDS, MINUTES, or HOURS.<p class="- topic/p p">Default is 10 seconds: ${10 *
                  SECONDS}. </p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Max Batch Size (records)</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Maximum number of records to include in a batch.</td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Max Clob Size (characters)</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Maximum number of characters to be read in a Clob field. Larger data is
                truncated.</td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Max Blob Size (bytes)</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">
                <p class="- topic/p p">Maximum number of bytes to be read in a Blob field. </p>
              </td>
            </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Number of Retries on SQL Error</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Number of times the origin tries to execute the query
                                        after receiving an SQL error. After retrying this number of
                                        times, the origin handles the error based on the error
                                        handling configured for the origin.<p class="- topic/p p">Use to handle
                                            transient network or connection issues that prevent the
                                            origin from submitting a query.</p><p class="- topic/p p">Default is 0.
                                        </p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Convert Timestamp to String</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2"><span class="- topic/ph ph">Enables the origin to write
                  timestamps as string values rather than datetime values. Strings maintain the
                  precision stored in the source system.</span><p class="- topic/p p"><span class="- topic/ph ph">When writing timestamps to <span class="- topic/ph ph">Data Collector</span> date or time data
                    types that do not store nanoseconds, the origin stores any nanoseconds from the
                    timestamp in a <a class="- topic/xref xref" href="../Pipeline_Design/FieldAttributes.html#concept_xfm_wtp_1z">field attribute</a>.</span></p></td>
                                </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__1">Additional JDBC Configuration Properties</td>
              <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_xkt_kww_gmb__table_nkm_dlr_bs__entry__2">Additional JDBC configuration properties to use. To add properties, click
                  <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Add</span> and define the JDBC property name and value. <p class="- topic/p p">Use the
                  property names and values as expected by JDBC. </p></td>
            </tr>
                            </tbody></table></div>
                </div>
            </li><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">Credentials</span> tab, configure the following
                    properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_xkt_kww_gmb__table_elv_hff_jmb" data-ofbid="task_xkt_kww_gmb__table_elv_hff_jmb" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row" id="task_xkt_kww_gmb__row-CredentialsTabHeading">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_xkt_kww_gmb__row-CredentialsTabHeading__entry__1">Credentials Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_xkt_kww_gmb__row-CredentialsTabHeading__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row">
                        <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__row-CredentialsTabHeading__entry__1">Username</td>
                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__row-CredentialsTabHeading__entry__2"><span class="- topic/ph ph">User name for the JDBC connection.</span><p class="- topic/p p"><span class="- topic/ph ph">The user account must have the correct
                                    permissions or privileges in the database. </span>
                            </p></td>
                    </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_xkt_kww_gmb__row-CredentialsTabHeading__entry__1">Password</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_xkt_kww_gmb__row-CredentialsTabHeading__entry__2"><span class="- topic/ph ph">Password for
                                the JDBC user name. </span><div class="- topic/note note tip note_tip"><span class="note__title">Tip:</span> <span class="- topic/ph ph" id="task_xkt_kww_gmb__ph-runtimeresources_credstores">To
                        secure sensitive information such as user names and passwords, you can use
                              <a class="- topic/xref xref" href="../Pipeline_Configuration/RuntimeValues.html#concept_bs4_5nm_2s" title="Similar to runtime properties, runtime resources are values that you define in a file local to the Data Collector and call from within a pipeline. But with runtime resources, you can restrict the permissions for the files to secure information.">runtime resources</a> or <span class="- topic/ph ph"><a class="- topic/xref xref" href="../Configuration/CredentialStores.html#concept_bt1_bpj_r1b">credential stores.</a></span></span></div></td>
                                </tr>
                            </tbody></table></div>
                </div>
            </li><li class="- topic/li task/step li step" id="task_xkt_kww_gmb__JDBC-Advanced" data-ofbid="task_xkt_kww_gmb__JDBC-Advanced">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">Advanced</span> tab, optionally configure advanced
                    properties.</span>
                <div class="- topic/itemgroup task/info itemgroup info">The defaults for these properties should work in most cases:<div class="table-container"><table class="- topic/table table frame-all" id="task_xkt_kww_gmb__table_z1c_hjj_kw" data-ofbid="task_xkt_kww_gmb__table_z1c_hjj_kw" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Advanced Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Maximum Pool Size </td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Maximum number of connections to create. <p class="- topic/p p">Default is 1. The recommended value
                  is 1.</p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Minimum Idle Connections</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Minimum number of connections to create and maintain. To define a fixed
                connection pool, set to the same value as Maximum Pool Size. <p class="- topic/p p">Default is 1.
                </p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Connection Timeout (seconds)</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Maximum time to wait for a connection. Use a time constant in an expression to
                define the time increment. <div class="- topic/p p">Default is 30 seconds, defined as follows:
                  <pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>${30 * SECONDS}</code></pre></div></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Idle Timeout (seconds)</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Maximum time to allow a connection to idle. Use a time constant in an
                expression to define the time increment. <p class="- topic/p p">Use 0 to avoid removing any idle
                  connections.</p><p class="- topic/p p">When the entered value is close to or more than the maximum
                  lifetime for a connection, <span class="- topic/ph ph">Data Collector</span> ignores the idle
                  timeout.</p><div class="- topic/p p">Default is 10 minutes, defined as follows:
                  <pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>${10 * MINUTES}</code></pre></div></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Max Connection Lifetime (seconds)</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Maximum lifetime for a connection. Use a time constant in an expression to
                define the time increment. <p class="- topic/p p">Use 0 to set no maximum lifetime.</p><p class="- topic/p p">When a maximum
                  lifetime is set, the minimum valid value is 30 minutes.</p><div class="- topic/p p">Default is 30
                  minutes, defined as follows: <pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>${30 * MINUTES}</code></pre></div></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Auto Commit</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Determines if auto-commit mode is enabled. In auto-commit mode, the database
                commits the data for each record. <p class="- topic/p p">Default is disabled.</p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Enforce Read-only Connection</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Creates read-only connections to avoid any type of write. <p class="- topic/p p">Default is
                  enabled. Disabling this property is not recommended. </p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Transaction Isolation</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Transaction isolation level used to connect to the database. <p class="- topic/p p">Default is the
                  default transaction isolation level set for the database. You can override the
                  database default by setting the level to any of the following:</p><ul class="- topic/ul ul" id="task_xkt_kww_gmb__ul_arc_mdf_2y" data-ofbid="task_xkt_kww_gmb__ul_arc_mdf_2y">
                  <li class="- topic/li li">Read committed </li>
                  <li class="- topic/li li">Read uncommitted </li>
                  <li class="- topic/li li">Repeatable read</li>
                  <li class="- topic/li li">Serializable</li>
                </ul></td>
            </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Init Query</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2"><span class="- topic/ph ph">SQL query to perform immediately after the stage
                  connects to the database. Use to set up the database session as needed. </span><p class="- topic/p p">The query is performed after each connection to the
                  database. If the stage disconnects from the database during the pipeline run, for
                  example if a network timeout occurrs, the stage performs the query again when it
                  reconnects to the database. </p></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1"><a class="- topic/xref xref" href="JDBCConsumer.html#concept_egw_d4c_kw">Create JDBC Header Attributes</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2"><span class="- topic/ph ph">Adds JDBC header attributes
                  to records. The origin creates JDBC header attributes by default. </span></td>
                                </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">JDBC Header Prefix</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Prefix for JDBC header attributes. </td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">Disable Query Validation</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Disables the query validation that occurs by default. Use to avoid time
                consuming query validation situations. <div class="- topic/p p">
                  <div class="- topic/note note warning note_warning"><span class="note__title">Warning:</span> Query validation prevents running a pipeline with invalid
                    queries. Use this option with care. </div>
                </div></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__1">On Unknown Type</td>
              <td class="- topic/entry entry colsep-0 rowsep-0" id="task_xkt_kww_gmb__entry-JDBCunknownType" headers="task_xkt_kww_gmb__table_z1c_hjj_kw__entry__2">Action to take when encountering an unsupported data
                  type:<ul class="- topic/ul ul" id="task_xkt_kww_gmb__ul_jcm_gdc_41b" data-ofbid="task_xkt_kww_gmb__ul_jcm_gdc_41b">
                  <li class="- topic/li li">Stop Pipeline - Stops the pipeline after completing the processing of the
                    previous records.</li>
                  <li class="- topic/li li">Convert to String - When possible, converts the data to string and continues
                    processing. </li>
                </ul></td>
            </tr>
                            </tbody></table></div></div>
            </li><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/ph ui-d/uicontrol ph uicontrol">SAP HANA</span> tab, configure the following
                    properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_xkt_kww_gmb__table_kg1_bdw_3mb" data-ofbid="task_xkt_kww_gmb__table_kg1_bdw_3mb" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry align-left colsep-1 rowsep-1" id="task_xkt_kww_gmb__table_kg1_bdw_3mb__entry__1">SAP HANA Property</th>
                                    <th class="- topic/entry entry align-left colsep-0 rowsep-1" id="task_xkt_kww_gmb__table_kg1_bdw_3mb__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry align-left colsep-1 rowsep-1" headers="task_xkt_kww_gmb__table_kg1_bdw_3mb__entry__1">Split Batch Commands</td>
                                    <td class="- topic/entry entry align-left colsep-0 rowsep-1" headers="task_xkt_kww_gmb__table_kg1_bdw_3mb__entry__2">Enables reading from multiple partitions at the same
                                        time. For more information, see the <a class="- topic/xref xref" href="https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.04/en-US/077d30cc847443288d3f0574356de4e7.html?q=splitBatchCommands" target="_blank" rel="external noopener">SAP HANA
                                            documentation</a>.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry align-left colsep-1 rowsep-0" headers="task_xkt_kww_gmb__table_kg1_bdw_3mb__entry__1"><a class="- topic/xref xref" href="SAPHana.html#concept_o1q_zkj_jmb">Include SAP HANA Connection Details</a></td>
                                    <td class="- topic/entry entry align-left colsep-0 rowsep-0" headers="task_xkt_kww_gmb__table_kg1_bdw_3mb__entry__2">Includes the information used to connect to the database
                                        in SAP HANA record header attributes.</td>
                                </tr>
                            </tbody></table></div>
                </div>
            </li></ol></section>
    </div>
</article></article></article></main></div>

                        
                        
                        


                    </div>
                    
                </div>
            </div>


        </div> <nav class="navbar navbar-default wh_footer" data-whc_version="25.0">
  <div class=" footer-container  mx-auto">
    <!-- script for Data Collector, all flavors, but only used when accessed directly, not from portal --><script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-60917135-3', 'auto');
  ga('send', 'pageview');
</script>
  </div>
</nav>

        
        <div id="go2top">
            <span class="oxy-icon oxy-icon-up"></span>
        </div>
        
        <!-- The modal container for images -->
        <div id="modal_img_large" class="modal">
            <span class="close oxy-icon oxy-icon-remove"></span>
            <!-- Modal Content (The Image) -->
            <div id="modal_img_container"></div>
            <!-- Modal Caption (Image Text) -->
            <div id="caption"></div>
        </div>
        
        
        Â© 2023 StreamSets, Inc.

    </body>
</html>